
package com.sxl.controller.admin;

import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import com.sxl.controller.MyController;

@Controller("lbtController")
@RequestMapping(value = "/admin/lbt")
public class LbtController extends MyController {

	@RequestMapping(value = "/frame")
	public String frame(Model model, HttpServletRequest request, String flag) throws Exception {
		return "/admin/lbt/frame";
	}

	@RequestMapping(value = "/list")
	public String list(Model model, HttpServletRequest request, String flag) throws Exception { // select
																								// date_format(insertDate,
																								// '%Y-%m-%d
																								// %H:%i:%s')

		String sql = "select a.* from t_lbt a where 1=1 ";

		sql += " order by id desc";
		List list = db.queryForList(sql);
		request.setAttribute("list", list);
		return "/admin/lbt/list";
	}

	@RequestMapping(value = "/editSave")
	public ResponseEntity<String> editSave(Model model, HttpServletRequest request, Long id, String flag, String pic)
			throws Exception {
		int result = 0;
		if (id != null) {
			String sql = "update t_lbt set pic=? where id=?";
			result = db.update(sql, new Object[] { pic, id });
		} else {
			String sql = "insert into t_lbt(pic) values(?)";
			result = db.update(sql, new Object[] { pic });
		}
		if (result == 1) {
			return renderData(true, "操作成功", null);
		} else {
			return renderData(false, "操作失败", null);
		}
	}

	@RequestMapping(value = "/editDelete")
	public ResponseEntity<String> editDelete(Model model, HttpServletRequest request, Long id, String flag)
			throws Exception {

		String sql = "delete from t_lbt where id=?";
		int result = db.update(sql, new Object[] { id });
		if (result == 1) {
			return renderData(true, "操作成功", null);
		} else {
			return renderData(false, "操作失败", null);
		}

	}

	@RequestMapping(value = "/edit")
	public String edit(Model model, HttpServletRequest request, Long id, String flag) throws Exception {
		if (id != null) {
			// 修改
			String sql = "select * from t_lbt where id=?";
			Map map = db.queryForMap(sql, new Object[] { id });
			model.addAttribute("map", map);
		}
		String sql = "";

		return "/admin/lbt/edit";
	}
}
